The CDate and Date functions are equivalent to DateValue. However, Date can only be used in Crystal syntax since it is a type name in Basic syntax.
string is a text string representing a date, example: "September 20, 1999". | |
DateValue (string) returns a Date value given a string that represents a date from January 1, 100 through December 31, 9999.
DateValue (number) returns a Date value given a number of days starting from December 30, 1899. Number can be positive or negative, and truncated if fractional.
DateValue (dateTime) returns the date portion of a given DateTime value.
DateValue (YYYY, MM, DD) returns a Date value given numeric arguments of the year, month and day.
The following examples are applicable to both Basic and Crystal syntax:
Returns the Date value for Dec. 31, 1999.
Returns the Date value for February 18, 1900.
DateValue (#Oct. 20, 1999 12:02pm#)
Returns the Date value for October 20, 1999.
Returns the Date value for July 30, 1930.
You can use the IsDate function to check if a String argument can be converted to a Date before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |